Daily Wire Payment File Drop By Partner Report

The purpose of this document is to explain the Daily Wire Payment File Drop By Partner report.

Using the Cross River Operating System (COS) Wire API, you can both originate and receive wire transfers through the Fedwire system. The level of information required varies depending on whether the transaction is purely domestic or international. Domestic wire payments require less information.

The table below shows the different columns included in the report together with descriptions and explanations of the information they represent.

Glossary

Term

Meaning

CRB

Cross River Bank

Partner

CRB’s immediate customer, i.e. you

Column

Description

Id

Indicates which type of identification information is used. This will be shown as a single character as follows:

  • B - SWIFT Bank Identifier Code (BIC)

  • C - CHIPS Participant

  • D - Demand Deposit Account (DDA) Number

  • F - Fed Routing Number

  • T - SWIFT BIC or Bank Entity Identifier (BEI) and account number

  • U - CHIPS Identifier

AccountNumber

The number of the sub account under the Partner’s relevant master account.

CoreTransactionId

What is this?

ReferenceId

Where does this come from?

ClientBatchId

What is the client batch?

ClientBatchSequence

Does this relate to each record and its location in the batch?

FedBatchId

Is this the ID for the batch this payment was part of?

FedBatchSequence

Does this relate to each record and its location in the batch?

Direction

The direction of this transfer. The options are:

  • Inbound: a payment received from another bank.

  • Outbound: a payment being sent to another bank.

Source

What source? Is it the account source?

Status

Status indicates the payment status which could be:

  • Created: the payment has been received but hasn’t been processed yet. This status will only appear briefly.

  • Pending: the payment is waiting to be batched and sent to the through the Fedwire system.

  • Hold: the payment is currently being held and is being reviewed by CRB’s Operations team.

  • Batched: the payment has been batched, and CRB is carrying out a final review before the payment is sent in a batch file through the Fedwire system.

  • Processing: For inbound payments, we are attempting to post the payment to the receiving account. For outbound payments, the payment has been sent to the FRB, but has not been posted yet. An outbound standard payment may remain in this status for a day or more.

  • Completed: the payment has been posted and accepted by the FRB (in the case of outbound payments). This is a final status.

  • Canceled: Indicates that an outbound payment has been canceled at the Partner’s request. A payment can only be canceled while either pending or on hold. This is a final status.

  • Rejected: CRB’s Operations team was unable to process the payment and has rejected it. For inbound payments, the payment request is returned to the originating bank. This is a final status.

PaymentType

A description of the payment type, which could be one of the following:

  • Transfer: a new payment originating from either CRB or another bank. Most payments are of this type.

  • Drawdown: a request for a drawdown.

  • DrawdownResponse: indicates the payment is a response to a drawdown request.

  • ServiceMessage: This entry represents an informational message transferred between banks and not an actual payment. This is used when there’s a relationship to a previously processed wire. Is this true?

  • Reversal: reversal of a previously sent wire payment.

Posting

What information could be shown here? Pending? Failed? Successful?

Purpose

Purpose of what?

Amount

The transaction amount.

Currency

The currency the payment is being or was made in.

Imad

This is the mandatory unique number given to each Fedwire payment when using the Federal Reserve Bank Service. You can use this number to track your wire transfer.

  • IMAD indicates an inbound transfer

  • OMAD indicates an outbound transfer

Omad

ReceiptDate

The date the payment was received.

ReceiptTime

The time of day the payment was received.

BusinessFunctionCode

This will always be shown as CTR for a customer transfer. Do we only use CTR?

TypeCode

This column shows the type of transfer taking place and can show one of these codes:

  • 10: indicates a funds transfer in which the sender and/or receiver may be a bank or a third party.

  • 15: indicates a foreign-funds transfer to or from a foreign central bank or government, or an international organization with an account at the Federal Reserve Bank of New York.

  • 16: indicates a settlement transfer with another Fedwire member.

SenderRoutingNumber

This is the sender’s ABA number.

SenderName

The name of the party sending the transfer.

SenderReference

What reference is this?

ReceiverRoutingNumber

This is the receiver’s ABA number.

ReceiverName

The name of the party receiving the transfer.

OriginatorToBeneficiary1

This is optional free-text information included by the originator to the beneficiary. An example could be:

OriginatorToBeneficiary2

OriginatorToBeneficiary3

OriginatorToBeneficiary4

OriginatingFiIdCode

This is the single-character code indicating the originating institution’s type as follows:

  • B - SWIFT Bank Identifier Code (BIC)

  • C - CHIPS Participant

  • D - Demand Deposit Account (DDA) Number

  • F - Fed Routing Number

  • T - SWIFT BIC or Bank Entity Identifier (BEI) and account number

  • U - CHIPS Identifier

OriginatingFiIdentifier

This shows the originating institution’s identifier as per the selected FiIdCode.

OriginatingFiName

The name of the originating party’s financial institution.

OriginatingFiAddress1

Address details of the originating party’s financial institution.

OriginatingFiAddress2

OriginatingFiAddress3

OriginatorIdCode

This is the single-character code to indicate the originator type. The code selected determines which identifier information must be used and is shown for the originator as follows:

  • B - SWIFT Bank Identifier Code (BIC)

  • C - CHIPS Participant

  • D - Demand Deposit Account (DDA) Number

  • F - Fed Routing Number

  • T - SWIFT BIC or Bank Entity Identifier (BEI) and account number

  • U - CHIPS Identifier

  • 1 - Passport Number

  • 2 - Tax Identification Number

  • 3 - Driver’s License Number

  • 4 - Alien Registration Number

  • 5 - Corporate Identification

  • 9 - Other Identification

OriginatorIdentifier

This is the orignator’s ID infotmation determiend by the code used in the previous column.

OriginatorName

The name of the party originating the transfer.

OriginatorAddress1

Address details of the originating party.

OriginatorAddress2

OriginatorAddress3

IntermediaryFiIdCode

This is the single-character code indicating the intermediary institution’s type as follows:

  • B - SWIFT Bank Identifier Code (BIC)

  • C - CHIPS Participant

  • D - Demand Deposit Account (DDA) Number

  • F - Fed Routing Number

  • T - SWIFT BIC or Bank Entity Identifier (BEI) and account number

  • U - CHIPS Identifier

IntermediaryFiIdentifier

This shows the intermediary institution’s identifier as per the selected FiIdCode.

IntermediaryFiName

The name of the intermediary financial institution. This will be empty If an intermediary institution is not being used for this transaction. is this true?

IntermediaryFiAddress1

Address details of the intermediary financial institution.

IntermediaryFiAddress2

IntermediaryFiAddress3

BeneficiaryFiIdCode

This is the single-character code indicating the beneficiary institution’s type as follows:

  • B - SWIFT Bank Identifier Code (BIC)

  • C - CHIPS Participant

  • D - Demand Deposit Account (DDA) Number

  • F - Fed Routing Number

  • T - SWIFT BIC or Bank Entity Identifier (BEI) and account number

  • U - CHIPS Identifier

BeneficiaryFiIdentifier

This shows the beneficiary institution’s identifier as per the selected FiIdCode.

BeneficiaryFiName

The name of the beneficiary party’s financial institution.

BeneficiaryFiAddress1

Address details of the beneficiary’s financial institution.

BeneficiaryFiAddress2

BeneficiaryFiAddress3

BeneficiaryIdCode

This is the single-character code to indicate the beneficiary type. The code selected determines which identifier information must be used and is shown for the beneficiary as follows:

  • B - SWIFT Bank Identifier Code (BIC)

  • C - CHIPS Participant

  • D - Demand Deposit Account (DDA) Number

  • F - Fed Routing Number

  • T - SWIFT BIC or Bank Entity Identifier (BEI) and account number

  • U - CHIPS Identifier

  • 1 - Passport Number

  • 2 - Tax Identification Number

  • 3 - Driver’s License Number

  • 4 - Alien Registration Number

  • 5 - Corporate Identification

  • 9 - Other Identification

BeneficiaryIdentifier

This is the beneficiary’s ID information determiend by the code used in the previous column.

BeneficiaryName

The name of the beneficiary party.

BeneficiaryAddress1

Address details of the beneficiary party.

BeneficiaryAddress2

BeneficiaryAddress3

BeneficiaryReference

What reference is this?

ReleasedAt

The date and time the payment was released.

ProcessedAt

The date and time the payment was processed.

EffectiveDate

The actual date the transaction was posted. Is this correct?

CreatedAt

The date and time the payment was initiated.

CanceledAt

The date and time the payment was canceled.

RejectedAt

The date and time the payment was rejected.

CompletedAt

The date and time the payment was completed.

PostedAt

The date and time the payment was posted.

OriginalPaymentId

What is the “original” related to? and what is this ID?

ProductId

The COS product identifier for the products included with your COS package. What are the different product ID numbers?

PartnerId

The Partner’s CRB identification number.

LastModifiedAt

What was modified?

InsertedAt

What was inserted?